CREATE PROCEDURE PDA_InsertOverUnderFactor
    @Id_Havaleh VARCHAR(MAX),
    @AutoIdOverUnder VARCHAR(MAX),
    @OverUnderAmount VARCHAR(MAX),
    @OverUnderPercent INT = 100
AS


DECLARE @PersonCode VARCHAR(MAX) 
--DECLARE @Id_Havaleh VARCHAR(MAX) = '22250'
--DECLARE @AutoIdOverUnder VARCHAR(MAX) = '9'
--DECLARE @OverUnderPercent INT = 100
--DECLARE @OverUnderAmount VARCHAR(MAX) = '550000'

SET @PersonCode =
(
    SELECT TOP 1 Reciver FROM dbo.TmpHavaleh WHERE Id_Havaleh = @Id_Havaleh
);

DELETE FROM dbo.Tmp_Over_Under_Factor
WHERE Id_Havaleh = @Id_Havaleh;
EXEC dbo.CalcIncrementalDeductionFactor @FactorId = @Id_Havaleh,
                                        @KindFactor = 7,
                                        @PersonCode = @PersonCode,
                                        @PersonPercent = 0.0,
                                        @IsCalcIncrementalDeductionRow = 1;


INSERT INTO dbo.Tmp_Over_Under_Factor
(
    Id_Havaleh,
    Name,
    Code_Over_Under,
    Type,
    Price,
    [Percent],
    Act_Code,
    Price_Row,
    Guy_Code,
    Max_Price,
    Max_percent,
    ShowPrice,
    Auto_id_Havaleh,
    Note
)
(SELECT @Id_Havaleh,
        Name,
        @AutoIdOverUnder,
        Type,
        @OverUnderAmount,
        @OverUnderPercent,
        Act_Code,
        0,
        @PersonCode,
        Max_Price,
        Max_Percent,
        ShowPrice,
        0,
        ''
 FROM dbo.Over_Under
 WHERE AutoId = @AutoIdOverUnder);


